The San Francisco 49ers quarterback's journey from 'Mr Irrelevant' to Super Bowl LVIII is one for the ages