ORDER BY ContentPageSetOrder DESC
But you actually don't need a recordset at all for this. If you just add the cms reference to that column and content area it will automatically show the most recent one.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.