A viral TikTok video posted by the Royal Armouries Museum in Leeds that hit nearly 10 million views globally has resulted in a surge in visitor numbers through the doors.