I dont understand why this cannot be a view ?
If you can SELECT from a table you can SELECT from a view.
Just make sure you ORDER BY on the SELECT not the view and job should be done.
But i do agree with the others, putting this sort of artificial constraint in place can only hurt you.