As someone who very much enjoys going to cafes solo and just observing, in my experience people sitting alone are definitely a small minority, unless they’re there with a laptop. This even in my stereotypically introverted culture (Finns).