alter sequence <tableName>_id_seq restart with 1;
For an instance, we have a table named "groups" and we need to reset the id sequence with 1.
alter sequence groups_id_seq restart with 1;
ALTER SEQUENCE product_id_seq RESTART WITH 1000;
ALTER SEQUENCE inv.inventory_item_status_inventory_item_status_id_seq RESTART WITH 6