Scots mother-with stage four cancer has been told by Nicola Sturgeon she can take a “final holiday”