Define the concept of Nash Equilibrium in non-cooperative games. Analyze why a Nash Equilibrium might not necessarily represent the most socially optimal outcome (referencing the Prisoner's Dilemma). Theoretically discuss the conditions required for a Nash Equilibrium to exist in mixed strategies and evaluate the stability of these equilibria in multi-player, infinite-game scenarios.