A Cardiff Half Marathon runner has died after collapsing at the finish line in what organisers have called a 'terrible tragedy'.