Frank Lampard says it will be an emotional but proud day as he plays his last game in the Premier League when Manchester City take on Southampton.