A major study involving two million people has unveiled surprising effects of weight-loss drugs like Ozempic and Wegovy.