One of Nicola Sturgeon’s handpicked Brexit advisers has poured cold water on her proposals to keep Scotland in the EU single market even if the UK leaves, only hours before she unveils them on Tuesday morning.