By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tablename (`id` INTEGER, `values` INTEGER);
INSERT INTO tablename (`id`, `values`) VALUES
('1', '1'), ('2', '1'), ('3', '1'),
('4', '2'), ('5', '2'), ('6', '2');
Records: 6 Duplicates: 0 Warnings: 0
SELECT *
FROM tablename
ORDER BY ROW_NUMBER() OVER (PARTITION BY `values` ORDER BY id),
`values`;
| id | values |
|---|---|
| 1 | 1 |
| 4 | 2 |
| 2 | 1 |
| 5 | 2 |
| 3 | 1 |
| 6 | 2 |