Yes, it is fine, and could be used either if you need transportation or if you just want the pleasurable experience. If you need transportation, we as often say 'would you give me a lift in your car'.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.