Tourism supports Scotland’s economic growth as optimism improves