By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
`id` INT PRIMARY KEY AUTO_INCREMENT
);
INSERT INTO test VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
Records: 10 Duplicates: 0 Warnings: 0
UPDATE test SET `id` = `id` + 1 WHERE `id` > 1;
Duplicate entry '3' for key 'test.PRIMARY'
UPDATE test SET `id` = `id` + 1 WHERE `id` > 1 ORDER BY `id` DESC
Rows matched: 9 Changed: 9 Warnings: 0
SELECT * FROM test;
| id |
|---|
| 1 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |