A new report reveals which soda is the number one brand in the US, according to consumer sales data - and it might not be the can you expect.