Metal detectorist Paul Collingwood has won £50,000 after spending just £4 on Betfred's New York Lottery.