You state that you're trying to set an xpath in an exclusive split. This will not work as xpaths can't be used there. You could try to retrieve the order from the database with an xpath (return first):
[PizzaMario.Order_Customer = $Customer] [OrderNumber = 10]
then use a split to determine if the order != empty and then the rest of you flow
To answer your question:
I would ask what the context of this microflow is, generally speaking. Are you updating customers to VIPs on a scheduled event, only when you click a microflow button, or some other trigger?
One option is to do a nightly scheduled event that promotes customers (you could do real time using event triggers as well).
If not, retrieve their 10th order (Entity: Order, Range: First)
[OrderNumber = 10] [PizzaMario.Order_Customer = $Customer]
If Order != empty, set Customer VIP flag
This is essentially what Erwin has said, I just elaborated a little more so give him credit.
A note on your referenced document:
The guide you have linked is in reference to the XPath query language that Mendix uses. Within the Modeler, you never are writing full XPath expressions. It's because they are created for you!
Mendix takes your XPath constraints and local and global variables along with the domain model to generate an XPath query.
If you do any custom Java work and you need to retrieve data, you have to create the full XPath expression as referenced in your hyperlink.