SELECT Auto_increment FROM information_schema.tables WHERE table_name=’the_table_you_want’;

ALTER TABLE users AUTO_INCREMENT=1000;