You'll need to create a new table for that
I'm thinking the table would be something like this
-----------------------------------
|adoptable_id|sorting_number|
-----------------------------------
|_________1|____________2|
|_________2|____________3|
|_________7|____________1|
|_________4|____________1|
...
And then when you're fetching the adoptables from the owned_adoptables table, join it with the other table above and order the rows by the sorting_number field.
|