A new survey analysed 6.5 million tweets during the period US President Donald Trump announced his intention to ditch the Paris Climate Agreement