OP, our school has phonics books but when a child has read all of them in one stage, they are put on non-phonics books.
I wrote a comment saying could we please have phonics books, the others are causing DD to develop bad habits (e.g. guessing) and are not giving her enough words to actually practise her phonics on. The reply was 'unfortunately our book scheme doesn't match our phonics teaching programme' to which I replied 'do we need to do some fundraising for the school?'
But the reality is, the school (in our case at least) does have the funds to buy more phonics books. They just don't believe in them. They taught the whole class the GPC such as ay, oo, igh, ... but rather than giving a child a book that contains these, and other GPC they know, so they could actually practise what they have been taught, they are given 'easier' red-band non-phonics books...
We are doing similarly, sending non-phonics books back, providing our own phonics books.
From DD being on red and yellow books at the moment, I can tell you that it depends a bit on the particular scheme. So what Mrz says:
A very rough guide •pink book band s, a, t, p.i, n, m, d.g, o, c, k. ck, e, u, r. h, b, f, ff, l, ll, ss.
Red band j, v, w, x. y, z, zz, qu. ch, sh, th, ng. ai, ee, igh, oa, oo, ar, or, ur, ow, oi, ear, air, ure, er. In cvc words
We haven't encountered ai, ee, igh, oa, oo, ar, or, ur, ow, oi, ear, air, ure, er in red band, CVC or not. In Floppy's phonics, Big Cat phonics, Songbirds, and Jelly and Bean, these seem to first appear in yellow. IIRC!
Yellow band all the above but with adjacent consonant words such as stop, jump, train, bright etc
Songbirds in Yellow starts with adjacent consonants (6 books) and only then moves on to oo, ai, ow, etc (next 6 books). Other schemes don't seem to particularly bother with the adjacent consonants.
Blue /green/ orange bands - alternative spellings for the sounds
Yep, in blue especially the split digraphs. But blue and above there are very few phonics books around, I find.