The UK Government’s law officer for Scotland has offered his resignation to Downing Street amid plans to override provisions in the Brexit Withdrawal Agreement.