Aaron Rodgers confirms that it was him riding in the back of a truck holding a box of beer in a viral video