Sure. I do this all the time.
But take a hint from the olden days of when BASIC had line numbers and most people numbered their lines in increments of 10 ( 10, 20, 30, ... ).
Do that with your ordering column.
Now, if you change your mind about one number, you don't have to shuffle all the numbers around.
Say you had, indeed,
and you decided the 30 really should be before 20. So just change 30 to 15.
(Heck, I can remember numbering by 100 on occasion.)
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.