Reset MySQL auto_increment

ALTER TABLE mytable AUTO_INCREMENT = 8;

This sets the auto_increment ID to start from either 8 or its current value, whichever is higher.