A television advert for Magners cider has been banned by for suggesting the drink can boost confidence and lead to social success.