A “sea-change in attitude” is needed from the UK Government if Scotland is to be given a meaningful role in future Brexit negotiations with the EU, a minister has said.