King Charles will "bid the fondest of farewells" to the Royal train in 2027 as the locomotive will be retired as part of the monarch's attempts to reduce costs.