Scottish leader supports calls for new Brexit referendum