Former finance secretary says receiving role in John Swinney’s cabinet is an ‘extraordinary privilege’