Yes. If You want to change the order when the user click on Header of some column. Other way is everytime when the user click on header to "SELECT ..." again. I think it is much slower then just SET ORDER TO... DESCENDING/ASCENDING.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.