It depends on the type of warrant. Failure to pay a fine is not necessarily an arrestable offence.
The Police Scotland Warrants Standard Operating Procedure (710 kB PDF) states:
5.3 Whilst there is no legislative requirement for Officers to physically possess the warrant to force entry / effect arrest, it
would be considered best practice if a forced entry is anticipated.
There may be instances where this is not practically possible to
obtain the warrant in time or it may be geographically challenging to
do so. Possession of a scanned copy of the warrant would be good
practice on such occasions, again where the circumstances permit.
and
5.5.1 By virtue of Section 135 Criminal Procedure (Scotland) Act 1995 an apprehension warrant implies authority, where it is necessary
for its execution, to break open shut and lock fast places. Entry into
any house or building, therefore, may be affected by any constable in
order to execute the warrant in accordance with its terms and only as
a last resort.
and
5.6.1 An Extract Conviction/Means Enquiry Warrant (back fine warrant) is issued by the Clerk of Court when an accused person fails
to pay the fine imposed within the period allowed for payment. This
extract is a sufficient warrant for the apprehension of the accused,
but unlike an ordinary warrant of arrest, it does not authorise a
constable to break open doors in order to affect arrest.
Sheriff officers are not police - they are closer to what in England and some parts of the USA would be termed bailiffs, used for civil recovery of debts etc.