Chelsea legend: Lampard appointed manager of 'ambitious' Coventry