DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (id TINYINT AUTO_INCREMENT, PRIMARY KEY (id));
ALTER TABLE t1 AUTO_INCREMENT=125;
INSERT INTO t1 SET id=NULL;
SELECT * FROM t1 ORDER BY id DESC LIMIT 2;
id
125
INSERT INTO t1 SET id=NULL;
SELECT * FROM t1 ORDER BY id DESC LIMIT 2;
id
126
125
INSERT INTO t1 SET id=NULL;
SELECT * FROM t1 ORDER BY id DESC LIMIT 2;
id
127
126