Andrew Bowie MP has been named as the new Shadow Secretary of State for Scotland by Kemi Badenoch.