#sql
SET @id = (SELECT id FROM test ORDER BY id DESC LIMIT 99, 1);
DELETE FROM test WHERE id < @id;
ALTER TABLE test DROP id, ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT FIRST, AUTO_INCREMENT = 1;