how to move record up down top and bottom

Hi

I wanted to move record up or down or top or bottom if user selects up or down or top or bottom from select box. records are coming from database.

while saving record I am assigning no. to every record like 1,2,3,...45,etc. It is not the case that every record will get increamented no. It may some record can be stored with same value like 35 some like 17 and so on.

and records are retrieved based on this no. means in ascending order..

Now I want to move record so how this will be done.