A Waterford National Lottery player who thought they had won €5,000 got the surprise of a lifetime when they realised their ticket was worth €1,005,000.