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.