Sorting ranking by trigger
There is no such thing as "physical order" in the relational databases. Sometimes queries can produce the ordered results but that should be considered as "ordered by coincidence". There is absolutely no guarantee that you get the same ordered result each time. 

If you need the ordered result the ORDER BY clause is a must.