Well you can do that using SQL query itself. Now let's say your default sorting format is by Price and let's say your product entry has a memberClassID. You would do the following:
"SELECT * FROM Products ORDER BY memberClassID DESC, Price"
What desc here does is order the results first and foremost by memberClassID (from highest to lowest and therefore class3 would be first) and then by Price in ASCENDING order.