PostgreSQL

set id auto_increasement:

select setval('tablename_id_seq', 1000, false);