During the live television draw for the Scottish Cup, rock legend Rod Stewart put on an enthusiastic performance that had viewers in stitches