Here below is a data table:

Sort in reverse order by the order combination of three columns (Maths, English, PE):

=spl("=E(?).sort(Maths:-1,English:-1,PE:-1)",A1:E12)

esProc Desktop and Excel Processing
10.2 Sorting of row-based data
10.4 Sorting of row-based data - by expression