London to Scotland service will offer en-suite cabins with sleek new styling, as sleeper trains experience a resurgence