He knew he likely needed a round in the sixties to get his card but mixed four birdies with one bogey and two double bogeys in a closing 72 to finish 49th in the final standings on 11-under par.

Caldwell will have full playing rights on the Challenge Tour in 2024, but 33 players secured full DP World Tour cards on 14-under or better.

They were headed by Germany’s Freddy Schott (22), who claimed the top card when he eagled the par-five 18th at the Lakes Course to card a six-under 65 and secure a two-stroke victory over Italian Filippo Celli on 27-under par.

“I'm unbelievably happy,” Schott said. “I knew it was going to come down to the final few holes. I had a chip-in on 14, made a good birdie on 16 and then the eagle putt dropping on 18 just made it a really good week.

“I wasn't really thinking about winning it but then after three or four days, I thought I might as well go for it and so I did.

“I couldn't have imagined that after last year I wouldn't be back on the DP World Tour. I've made some great friendships there this year and it's just amazing to play on the DP World Tour. That was my only goal this week.”

Belgian Matthis Besard fired a closing 65 to finish third on 23-under par alongside overnight leader Sebastian Friedrichsen from Denmark and Dutchman Darius van Driel.

The fairytale stories included New Zealand’s Sam Jones, Belgian Besard, English amateur Joshua Berry, Danish duo Jonathan Gøth-Rasmussen and Søren Broholt Lind, England’s Joe Dean and American James Nicholas, who came through all three stages to earn their cards.

But American John Catlin, who won the 2019 Irish Open at Galgorm Castle, missed out by just two strokes, finishing 46th on 12-under after a closing 71.