MYSQL: Incremental Sorting of Duplicate Numbers

I have a table that looks like this:

I would like to have them sorted incrementally in some sort of loop that orders them in this fashion

I believe this could be done easily with PHP however I would like to see if this can be done using SQL.

>Solution :

Use ROW_NUMBER() window function in the ORDER BY clause:

SELECT *
FROM tablename
ORDER BY ROW_NUMBER() OVER (PARTITION BY `values` ORDER BY id), 
         `values`;

See the demo.