Photo of little Christian McCaffrey celebrating dad's 1999 Super Bowl sparked his own Super Bowl ‘dream'