Sheriff Tiraspol produced one of the greatest Champions League shocks by defeating Real Madrid.