SQL if statement

[03Explorer]

I do not want to change values or add a field to a table, but I do want to change the sort order for a report but the order will be custom. I was thinking I can create a field for the sql code to generate on the fly to read a field and using a nested if statement populate the field with a number 1 - n. That way the number is not stored in the table and it can be adjusted if the order changes again.

Stumped.