Resetting auto-increment value for the post table:

ALTER TABLE wp_posts AUTO_INCREMENT=X;

Change wp_posts to correct table name if not using the default prefix (wp_). Change X to the value you want to set the next increment value to.