I would definitely expect the order by on the view there to be respected, whether or not that's in the SQL standard.