The CEO of Sainsbury’s has apologised after he was caught on camera singing “we’re in the money” following the Asda merger announcement.