The cheapest way to travel overnight to Scotland is a reclining Seat on the Caledonian Sleeper, with lead-in fares from around £50–£54 one way — far less than any private room. You get an adjustable seat with a headrest and footrest, reading light, table, power socket, USB port and lockable storage, with toilets in the coach, but no bed, shower or included breakfast. To get the lowest price, book as early as you can: fares are demand-based, tickets go on sale up to 12 months ahead, and the cheapest seats and berths sell first. Travelling midweek (Monday to Thursday) is typically cheaper than Friday or Sunday. If you want to lie flat but keep costs down, the entry-level Classic Room (from roughly £165, sole use) becomes much better value shared by two, since rooms are priced per room rather than per person. Families can save with family tickets, and children aged four and under travel free (one per paying adult). It's also worth comparing the total cost including a saved hotel night — because you sleep on the train, the sleeper can work out cheaper overall than a daytime train plus accommodation. In short: cheapest of all is a midweek, book-early reclining Seat; cheapest bed is a shared Classic Room.
Sources: seat61.com · sleeper.scot
Ready to travel? Compare cabins and fares, then book with confidence.