You'll get your desired result by sorting by the columns in reverse order of priority, that means, in your example, by ordering the array by the 4th column, then the 2nd, then the 1st.
It's likely not the fastest possible solution, but it yields the desired result.