Scotland best placed to take advantage of UK’s green transition, report finds