To add some numbers to that.
Classes 68 and 88 apparently have a ETH index of 96, Night Riviera's 57s are 100, but the Class 92s are index 180 on OLE.
The Mk3 sleepers are apparently an ETH of 6/7, but the Mk5a can be between 9 and 18 depending on the type.
I don't know if you could do something clever and have two locomotives supplying ETH to a train, but as it stands the 92s are the only ones capable of doing a full length Caledonian Sleeper. If at some point the Night Riviera stock requires replacement, presumably a similar issue would crop up.