Is there anyway of doing this

[Logician]

I meant:

If you are searching for a SELECT SQL query that will do what you asked, no, you cant find.

Instead:

First get your SQL result in the original form with simple SELECT query, ie:

1
2
3
4
6
8
9
12

Assign this result to an array with mysql_fetch_row command..

Now you will have an array like that:
$array[0]=1
$array[1]=2
$array[2]=3
..
$array[4]=6
$array[5]=8
..
$array[7]=12

Now since you have an array, you can do anything you like with this array. Do you want to switch 6 and 8, here you go:
$a=$array[5];
$array[5]=$array[6];
$array[6]=$a;

You'll have:
$array[0]=1
$array[1]=2
$array[2]=3
..
$array[4]=8
$array[5]=6
..
$array[7]=12

See?