The guitar belonging to the late musician and songwriter sold for £889,400 (€1,068,956) at Bonhams auction house.