I’ve caught the sleeper from London to Inverness. A fun experience but it was £800.
I would think the distance doesn’t affect the price since they can’t reuse the room. And I assume you pay per room too? My wife booked it so I’m not sure of the exact details. Maybe my assumptions are wrong!