CREATE TABLE table1_seq
(
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
);

you cannot reset the counter to a value less than or equal to any that have already been used.