A beloved childhood beverage has made a shock comeback to supermarket shelves after fans begged the brand to bring it back.