Tightening a guitar string increases its tension (T). The fundamental frequency (pitch) of a vibrating string is governed by:
f = (1/2L) × √(T/μ)
Since L and μ are constant for a given string on a given guitar, frequency is proportional to the square root of tension. Increasing T increases f, raising the pitch.
Intuitive version: A tighter string snaps back to equilibrium faster when plucked, vibrating more times per second = higher pitch. This is why tuning pegs wind to tighten (raise pitch) and unwind to loosen (lower pitch).