Police say a 27-year-old man died after being stabbed in the "shocking and tragic attack" in Crumpsall.