Coca-Cola Ireland has apologised after an advertisement on a website for Sprite caused uproar and was removed by the site which said it should never have featured.