Knight's Choice has won a photo finish in the 2024 Melbourne Cup having defied the odds to defeat the heavy favourites.