The Piggyback Ride trophy in Call of Duty: Modern Warfare Remastered is story-related and can not be missed.
You will unlock the trophy at the end of Mission 12 -- One Shot, One Kill.
If you're playing on Veteran difficulty, you will also unlock The Shot trophy at the end of this mission.