Adelaide has ended a 10-match losing streak to Collingwood with a thrilling last-gasp victory in front of a record crowd at Adelaide Oval.