[php]Setting display order for individual records?

Hi guys,

Right ok lets see if i can get this out my head.

DB setup

mID = autoincrement ID
mName= string info
mImg = string info
mOrder = number

Right ok so lets say i have 10 records
so mOrder would be 1-10 for each record.

Right so some time down the line i might want to change the mOrder for record 8 to 1. So record 1 would need to have the mOrder updated to 2 and so on for each other record

How do i do this?

Thanks for any help suggestions