MySQL 8.0

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