Sort Order has been change due to DB server movement
If you don't have an ORDER BY clause, the order of the result set is never guaranteed.


Connor Cunninghan No Seatbelt Expecting Order Without ORDER BY. In case it gets archived again
Aaron Bertrand showing another exmaple of this 


Also, you mentioned "report". If you are using SSRS or any reporting suite really, they have sort functions within them as well which means you wouldn't have to change any of your procedures or views.