Vanderbilt quarterback Diego Pavia apologized on Sunday night for his social media post after finishing runner-up for the Heisman Trophy