The chief executive of the Scotch Whisky Association, David Frost, is stepping down to become an advisor to UK Foreign Secretary Boris Johnson.