Yes - but travelling for work is an essential reason, so it's exempt from the stay at home order. It will also be exempt from whatever the "stay local" guidance thing is from 2nd April. As you say, though - for non-essential purposes we can't currently travel outside our council area and it sounds like it will be strongly discouraged even from 2nd April. So now we can't go down the road to another council area to see our parents just because we fancy it, and we can't go to England to see (another version of!) our parents just because we fancy it.
I think the main concern is that from 26th April NS has confirmed that we will be able to do the former within guidance - but the latter is still not confirmed. She did day she "hoped it would be 26th April or soon thereafter" or something like that in her briefing yesterday. But the actual official wording as pp have pointed out isn't so reassuring:
Currently non-essential travel between Scotland and the rest of the UK and the wider Common Travel Area (CTA) (i.e. the Republic of Ireland, the Channel Islands and the Isle of Man) is prohibited as a measure to reduce the risk of importation of the virus. Travel within the UK and the wider CTA is important to many families and to the tourism sector. We will keep that ban under review, taking account of trends in prevalence and the restrictions in place in the other CTA countries and the confidence we can take from that about the risks of travel resulting in importation of the virus, with a review to relaxing the ban – or targeting it only on travel to and from particular areas in the rest of the CTA – when it becomes safe to do so. We will continue to communicate our thinking with the tourism sector.
So no date given, reiteration of the ban and reviewing the ban, lots of scary sounding wording about importation of the virus, and "communicating our thinking with the tourism sector" - which I assume means "we'll tell you what's happening and make sure you comply with it by refusing bookings from people with an English address" or similar...
And of course, from 2nd-25th April we will legally be able to go to another council area in Scotland "just because" - albeit with lots of finger wagging and telling off about going against guidance. But we still won't be able to go to England, because that ban will still be in place (though not sure which piece of legislation actually includes the current CTA ban - as distinct from the "don't leave your house" ban or the "don't leave your council area" ban. Lots of bans there...)