Formulate an answer to this elaborate question: For which team does this American football quarterback in the National Football League (NFL) who scored a remarkable comeback as freshman in the 2000 Music City Bowl?
New York Giants