As has been pointed out, only the Pendolinos (tilting trains) run up to Scotland for Avanti at the moment. Maybe you could try Transpennine Express, who operate between Edinburgh/Glasgow and Manchester?
No idea where you're going, but you'd then have connections to a lot of the country from there.