Ghost the Musical opened to a standing ovation at Southampton's Mayflower Theatre on Tuesday night