It willIf I went with the two products you posted, would this be the adapter I'd need: https://www.toolstation.com/diamond-core-drill-adaptor-sds-plus/p62181
I have two, one with longer shaft.
You may or may not need a taper shank pilot drill too though I rarely need it even when core is 5” all the way from 28mm