Read the order associated with the given cart, once the cart has been converted into an
order by the provider.

This is a database-only lookup: it resolves the persisted cart-to-order relation and reads
the order, without calling any external provider. It works for a cart regardless of its
current status.

A successful request returns the order associated with the cart.