It may not be a major effect, but the smallest motions will be near the CG of the plane. So the last row of F (assuming F is in the front of the plane), the lower deck of the 747, and aisle seats will all have slightly less motion than their counterparts (just like a cruise ship, where the least motion is an inside cabin, midships, low deck).

Alcohol is generally also a bad idea, as it will dehydrate you. Hydration is critical for maintaing equilibrium.